This course is a type of financial modeling course that teaches how to build a pro forma model for a merger or acquisition transaction. A pro forma model is a projection of the combined financial statements of the acquirer and the target after the deal is completed.
It shows the impact of the transaction on key metrics such as revenue, earnings, cash flow, and valuation.
A Mergers & Acquisition Modelling course typically covers topics such as:
How to structure an M&A model in Excel.
How to set up the sources and uses of cash for the deal.
How to adjust the balance sheet for the purchase price allocation and goodwill.
How to forecast the income statement and cash flow statement of the combined entity.
How to calculate the accretion or dilution of earnings per share and other ratios.
How to perform sensitivity analysis on various assumptions and scenarios.
How to evaluate the strategic rationale and synergies of the deal.
Eligibilities
To be eligible for this course, you should have an academic degree (such as PhD, JD, DBA, MBA or Bachelor Degree) and/or a professional designation (such as CPA, CFA, CAIA or equivalent).
You should also have advanced Excel skills and be able to use functions and formulas such as SUMIFS, INDEX, MATCH, and XNPV12.
Note: Eligibility requirements may vary based on the specific course or program you choose. Please refer to the detailed course brochure for more information.
--- Finance and Banking
---
Mergers & Acquisition Modelling
Total Days
26 Days
+
Total Hours
170 Hours
Your Achievement,
Recognized
Successfully complete the Mergers Acquisition Modelling Program
and showcase your professional achievement with our certificate.
Certificate awarded upon successful completion of the program
Related Courses
Scenario & Sensitivity Analysis - Advance Excel Professional